SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106957 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106957 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626267,81423,527372,127629,645979,173308,561571,1023010,1047084,891119,575752,524676,466281,460050,94913,98302,590801,294646,199290,202393,459879,181881,162444,20025,840640,344172,198828,854199,135198,919973,450989,524351,208338,489451,849961,466257,906586,714181,919258,40553,557724,20257,880180,224230,395960,820862,402294,971437,402705,926493,391861,370913,797936,329791,269943,731659,594328,722566,878499,330088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001360s ]