SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326178 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326178 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754778,124475,1045828,422457,278684,942679,535487,814469,189327,155130,832665,483788,500515,146066,849327,228190,449531,376043,736040,460244,744373,611440,122302,637897,339530,437387,696532,181120,250201,83940,606640,747728,392509,432840,1026477,233937,880742,827891,975708,237910,620623,413448,525237,61197,758281,40769,928295,571122,955718,454924,654929,868689,578743,738679,993537,798914,586125,834069,964299,775896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]