SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10309 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10309 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874322,296120,170572,909161,962269,58073,1009295,952825,388417,882970,922907,400094,857447,581272,569528,571578,883628,555266,734272,336540,481916,171821,593526,222866,315330,940534,898839,1028074,890635,223046,643745,419533,95896,400314,434128,153086,839927,418018,808072,2606,503705,782475,292868,208242,329958,158950,994908,522938,187723,714289,177330,816833,12884,22482,641573,865090,494039,663727,860131,133815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]