SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 854710 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 854710 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004713,194089,662350,530803,299062,91075,897682,713726,807408,708171,284239,1025373,122080,343950,109454,525627,936420,376342,220108,227284,454169,309054,128663,474318,866850,639113,546266,147734,539899,582267,184736,1032905,531253,408505,254848,851776,635397,300710,795993,49734,177431,624420,842878,723005,264639,606483,910435,785541,443522,120689,1018688,762412,1015808,833436,327849,28722,357004,816501,995274,563713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 854710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 854710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]