SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001755s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023707 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023707 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466862,90870,108214,263477,965324,344111,101784,86898,681839,230860,403382,8798,1032811,265631,419244,634464,443618,1011043,752580,444113,242598,118019,288292,861384,703101,464507,2157,487228,344411,740786,1042851,877775,678417,790228,632322,751933,371803,847809,646095,884630,199212,845944,337388,277448,813641,902234,144026,600874,131414,847343,386860,491541,114892,52275,250714,342076,735726,441076,963481,549947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]