SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349046 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349046 [ RunTime:0.003165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774402,949445,501031,36158,844833,676813,242575,456410,752893,213244,197242,25372,863848,1027818,154297,937173,967138,217042,254041,339977,133075,455416,393380,71939,264215,787982,946355,954002,289486,750102,749001,885734,579364,347929,655237,630677,399558,142063,987279,817500,392880,786340,581144,221514,15967,252981,188120,309575,14263,730324,988180,650638,494473,552002,539472,74697,99001,421159,258795,146944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004910s ]