SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201313 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201313 [ RunTime:0.002766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985906,861226,979348,1001767,151180,954719,137586,483623,690743,914020,131884,382088,545571,315,114734,902050,49938,474789,219866,37741,395305,454381,799288,829415,1013517,729170,564375,95656,662481,585901,429857,483947,38096,333126,29127,35956,561290,813629,403683,494303,668465,691387,178030,905955,285361,329230,592056,361790,558180,384943,569042,7281,381421,828624,446161,31939,394387,20011,780828,433166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005466s ]