SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367601 LIMIT 1 [ RunTime:0.002471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367601 [ RunTime:0.003171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585271,882228,614774,341576,387320,372863,720192,275160,853898,521241,636073,1035577,950492,17447,149359,363850,401112,128734,772173,715620,108463,140867,193372,131644,865937,546279,289965,352955,426693,417947,452997,104268,991960,476085,496009,712351,528023,504673,649080,911577,628184,858245,302833,940776,385915,810752,78396,645184,171527,72291,1027975,466168,397976,760956,222706,43278,1000144,465743,787880,687667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]