SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340905 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340905 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219703,486233,466135,100630,208606,69681,998624,725784,57266,697510,897331,577339,621964,272029,727605,1025584,175814,832859,66980,854465,614739,594439,983958,20237,127037,1044602,978538,118103,946167,66414,373091,910321,31103,287474,936639,1027974,724683,918116,21115,617254,846729,259560,892805,214816,176519,180412,885476,105030,485353,380815,382583,790790,210584,469358,69695,815278,722052,459990,693481,545620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]