SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548520 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548520 [ RunTime:0.003027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11537,898326,971877,495923,2748,271402,13431,816257,362357,464146,977184,799485,995132,1007561,5843,604541,1038384,709805,824563,666666,386680,868593,13986,999340,238655,715240,453507,908857,904690,893358,390052,417612,352942,557124,583862,399003,103422,751515,14544,428691,179905,166904,71764,341936,732446,345033,996489,355224,82454,531920,715048,632991,543174,126994,945386,52203,728212,687885,130274,289405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]