SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108215 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108215 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245094,378892,681313,531949,854270,723283,321882,7837,570388,466333,307815,95046,571178,453010,934005,267902,750711,928964,667188,397008,806755,903151,1034916,313200,851226,98487,573501,570306,310959,377377,798537,875135,122810,422471,973380,959785,671942,238079,399187,527661,709348,809728,630223,838060,345209,972551,656399,675857,132464,294525,465966,73175,918346,135570,820350,177096,440843,328492,965007,457927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]