SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543535 LIMIT 1 [ RunTime:0.002478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543535 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108315,85712,58160,304595,312952,597401,581953,842984,209347,163698,374456,200886,477091,1044858,579515,1044383,736675,764594,257953,353288,995885,789700,94556,732493,1007219,641149,51000,581730,561123,478628,1025066,172061,840067,450948,369246,403145,467077,504391,151191,695385,533121,251717,1013821,752100,214128,869958,1038215,662987,780578,902089,834802,145566,298515,663335,1011129,448267,969813,135867,278146,856974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]