SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101987 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101987 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570215,375570,134118,48144,461624,857363,285007,616272,998670,781209,975604,696446,198289,568061,44848,336628,187436,732186,332423,133634,978042,8556,871212,671084,767810,886634,561810,889463,592617,178930,295362,109727,841819,98487,400005,1002405,240437,110678,1030398,376820,421253,108498,496814,655660,832924,747285,897258,218142,502935,167269,584739,131824,118866,437383,528826,532352,946791,736340,788132,127839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]