SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310512 LIMIT 1 [ RunTime:0.000861s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310512 [ RunTime:0.003661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596826,727291,874346,490356,721886,487813,765550,131974,119965,204021,7899,448749,732670,696331,145277,1712,407408,99523,864749,675544,653,568367,600907,1031816,697151,921669,334567,865516,198205,97362,579431,583514,792960,499813,548611,543847,710044,307428,18762,821507,638134,327081,301421,840060,297353,566615,920251,155818,104176,659750,211795,573115,941540,950720,194517,924963,184979,647373,95029,26395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000952s ]