SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170416 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170416 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260055,71802,812366,169175,277173,526214,631443,922254,279556,179607,904142,700316,982989,522748,160867,552233,724824,992534,634833,389997,250984,329535,718300,497866,662278,224606,746736,768941,246077,6887,200425,555490,264645,937342,955727,880096,83361,956869,575886,43263,326708,475481,347016,761094,39044,146325,506119,292903,340679,495327,209101,743973,99871,737726,1041628,317749,732926,646008,528783,492390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]