SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034187 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034187 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21883,609459,177532,420263,537035,891556,244251,853246,804992,196632,132940,673631,392557,183962,502286,555234,196486,135700,795721,29796,715933,328174,668511,399074,966234,592524,67119,526912,481247,1003255,934228,102164,397549,828875,505811,718705,702764,166179,482641,736709,355732,759769,245347,949370,885149,662227,808062,42797,84575,736660,313693,108883,5930,596297,143662,288133,876135,111059,139446,627033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]