SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109940 LIMIT 1 [ RunTime:0.002308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109940 [ RunTime:0.002368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521658,286226,226673,99680,349961,279854,89209,720333,483144,421633,733744,40618,612917,641405,605749,807674,116360,324838,540929,801819,344961,495064,157616,179621,461597,583199,404863,321612,574887,833169,1009526,329887,541084,433639,965439,226540,912568,168277,837185,51718,676341,1226,519902,216812,589833,763191,775569,765736,531214,939120,1038406,113739,399636,467614,136595,124137,768344,662656,877306,992532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]