SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420054 LIMIT 1 [ RunTime:0.003307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420054 [ RunTime:0.004319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009317,503500,838263,574164,160264,304839,983085,1041121,64297,862638,721719,664735,52036,61857,955456,38650,554712,176793,508760,719080,19108,221312,742342,184979,930063,341805,48860,1043072,383143,223245,42836,227701,143646,256873,725483,451659,383230,459819,507422,342029,917900,541841,315149,541130,686346,340864,648207,523129,596572,963263,739844,905292,28051,768485,189601,416136,456001,760953,953169,280452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]