SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539731 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539731 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366975,353262,616636,238253,310648,522011,130028,787913,34688,494954,1023467,87549,258693,462387,313396,729210,786605,115697,1033506,425482,590654,167184,575242,73591,233449,939045,198623,427252,903804,995143,349325,354032,573893,885770,777854,165111,1031843,207723,514935,932683,157215,855144,333730,86177,540746,778032,630253,907588,522606,465484,888301,908812,376231,886393,812037,342041,722742,568696,213510,931467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]