SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415331 LIMIT 1 [ RunTime:0.000716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415331 [ RunTime:0.002604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216549,1010658,708583,462052,413483,338773,1007153,319710,932755,261797,243333,828986,86080,478001,212788,401602,55981,401948,419706,693673,284685,546091,130530,416186,246596,274889,792059,460161,342306,615798,974883,523675,7761,214715,354912,105694,537438,380521,342922,718134,903807,353162,241771,583701,475327,811786,30382,703138,395503,576923,366658,157708,148027,453061,11159,842472,503881,383295,458216,74721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004178s ]