SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507689 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507689 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535580,407053,69818,789666,79314,287044,668088,553525,662299,385618,811900,94080,301220,727748,834267,706930,757865,48236,951854,744346,887395,134993,421376,811144,921909,1035838,307839,904322,636130,630089,276418,114807,805566,61703,452521,2410,801819,100655,411752,782941,670324,431930,467658,897875,957976,360632,74972,828370,208818,960072,659579,182118,73816,566060,635525,764625,47507,658484,1000822,967001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]