SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023760 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023760 [ RunTime:0.002161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852550,800068,101273,929750,19461,296585,44647,840495,12233,70038,594295,744053,749763,411628,904756,118701,738865,252960,810616,621206,928509,589110,803250,382241,604246,970680,556810,909660,737866,310609,89404,689003,816166,975940,172392,751412,831666,697596,702341,854968,622233,539660,241796,726365,190919,842601,379206,28324,278835,369249,122875,34592,427854,490345,497807,831241,304664,529160,693845,734588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]