SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620317 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620317 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022495,648375,661739,499087,940898,1042073,652318,298581,484658,406959,173104,544586,669116,172676,371612,420827,945033,587297,192464,1016033,106980,595302,666699,6062,566835,1011222,867348,664217,104948,805327,854944,861277,1020485,495334,219665,469263,44645,1012,851769,824980,357103,1011236,289768,378744,513109,465077,79167,1047629,432749,771718,170931,328418,870277,240738,428671,740590,968640,864448,784219,828741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]