SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001821s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920166 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920166 [ RunTime:0.002206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95421,798663,399163,549594,233213,563169,451983,546259,606078,810290,553102,272768,609566,640989,186914,152435,697636,541288,601328,959091,45321,1029330,487463,213201,440584,976756,661296,504728,766027,506896,691813,266386,1044626,794320,54230,499913,803150,16647,1040011,920711,882569,717085,52559,281982,256870,209430,10896,256974,26835,116518,754259,862407,666436,32740,38427,458541,941158,322105,422600,215078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]