SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390018 LIMIT 1 [ RunTime:0.000671s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390018 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187498,100597,895517,297787,516773,671458,197665,940298,190608,941805,160232,134208,979699,250116,965960,551350,840063,594871,908391,164130,515002,940141,113361,326653,407430,42143,254577,542392,838111,164343,14797,817520,956762,1005637,434929,531186,57516,728047,590027,696624,149188,863063,1008626,1014450,540937,584443,329404,473670,341876,554372,885586,295833,944089,233411,1044176,104408,605438,773032,661311,50698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]