SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412552 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412552 [ RunTime:0.005570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991126,941349,961248,1041600,676903,974181,477213,289227,370752,927006,63639,89657,853803,527206,249902,277120,885234,159613,101092,133544,285661,471626,252169,211069,894845,492540,433542,335831,1004545,859337,547873,1003161,848402,828436,776730,217694,445576,56807,597396,17175,812705,312182,290740,675380,86738,781332,597458,369972,353142,543234,470828,317413,112333,628223,393184,433020,781093,460829,801361,1010907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]