SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414863 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414863 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134430,61264,330813,556894,204263,354152,514297,991666,774147,88743,33450,559061,630879,384930,449439,804126,294904,79735,512204,266807,113947,282526,181610,63449,973356,852614,460212,268418,474946,72653,727158,439969,981653,313344,928121,958346,297501,391929,536276,708646,540835,508905,77800,26781,19422,1038894,365078,1016456,1033826,769799,111483,705363,710273,1014193,474322,41173,719240,690161,178609,432694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]