SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8151 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8151 [ RunTime:0.008445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031928,133605,320513,955479,19069,752151,970587,120541,952301,1021195,122492,528015,528274,467318,935120,623649,174957,685662,1038776,559251,522655,1035056,726930,250741,670857,572143,300449,406354,53446,10216,572299,16985,656536,1015216,832144,354657,144591,980308,330079,160045,795523,284609,796423,547291,9590,326421,426865,152108,1034477,714362,341781,752770,259304,475369,937717,521105,621214,80884,974193,686271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002736s ]