SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343283 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343283 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241247,215457,584748,351830,629467,683207,205680,305468,1003838,537610,632757,230827,772094,641996,567033,590503,690399,162841,1044631,630592,21861,462350,814951,578962,434485,649247,743297,389794,137697,228310,475317,828375,795891,208545,762456,156610,929999,286274,8739,744294,748348,606610,964257,512106,964657,310846,764988,12186,1019044,940250,592655,94025,573176,639842,736566,1007161,460675,877783,813205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]