SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566082 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566082 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9375,593478,205253,430586,783098,69019,587906,1023792,17116,601580,422946,329120,497551,961048,213519,488975,284729,920135,907315,718877,901719,293117,582411,480126,460128,430819,317619,192039,314416,621667,81995,146573,679506,738632,526655,468864,760195,46811,66683,570478,314073,960584,340845,767531,769990,803019,551440,684591,824062,474523,456464,152853,276832,524904,157637,813819,390613,211142,130907,744475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]