SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020672 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020672 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203238,834855,388590,968562,208865,279250,593847,429708,920734,455804,1045389,158361,463542,924477,985513,1033889,387616,376357,266196,856831,454337,1031274,294777,772052,53726,376852,811386,75376,628546,698365,285894,490214,939953,189508,750660,943330,893579,577830,231869,25944,761669,905513,271432,859006,789574,101210,55856,484770,386206,909093,685068,690826,923177,962585,312455,932750,110979,818476,520567,73624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]