SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424841 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424841 [ RunTime:0.003309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279923,757544,302493,268742,819662,570007,785172,543119,583379,227370,396016,609496,683212,469169,677820,347821,323573,243737,745806,391878,531670,290185,151718,890137,574055,319804,200490,636189,205043,1033423,857963,220296,34686,431690,57843,581632,83971,60129,224702,474613,931499,397283,1004732,136454,379890,553228,764369,28179,852379,250355,419509,314229,736922,292559,708749,587660,826649,372635,390536,1038437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]