SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434482 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434482 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544960,196408,982546,349252,966102,889901,433764,845383,761840,71337,465174,467406,412470,419985,312070,874790,334054,548766,424817,542651,317353,713571,1027008,774802,35429,986882,251385,803125,706512,170289,447120,579497,609924,655437,751212,969617,909125,352759,401975,354202,306796,578076,491483,876531,1031179,986799,123812,655581,696103,603282,1024553,152543,775019,561133,825089,641634,1018223,329224,437010,151366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]