SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507710 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507710 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522818,440989,147018,1035961,426872,799473,263844,20578,819679,599896,210448,58251,992342,962411,584899,556058,67063,593383,403056,778402,500168,261700,119209,689353,674973,91552,905071,472446,397952,295985,328743,235563,954015,926213,178943,452128,107614,393895,264972,989985,62307,757888,935265,818407,721029,657755,8869,448036,484908,577056,107158,886444,571957,745721,333125,934532,717428,464008,894441,946245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]