SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020240 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020240 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584924,419306,588644,865180,430965,181379,320066,208858,505760,580623,200745,205811,15138,406362,176175,497477,801576,234887,805107,722395,380773,1005143,680288,748256,448428,15220,150711,45172,661902,852820,55471,203544,528875,363171,541068,306587,1026102,415787,926237,410677,785513,1027271,264148,427066,398034,395599,585891,877964,332855,271259,526675,586061,81146,655335,394225,230074,737607,120777,826993,920460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]