SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004223 LIMIT 1 [ RunTime:0.004899s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004223 [ RunTime:0.007613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751962,475812,908442,744820,618110,190403,804056,979311,926234,512759,225343,47874,930556,948319,7553,113155,624568,671008,326850,328308,889692,15081,30090,228044,927464,831688,523324,643970,934293,122143,1013760,658360,46583,869579,349092,840844,45744,716292,341171,940443,514400,265056,1036225,332656,920251,803052,466354,271932,935323,97448,245597,282090,415201,60959,493368,748941,1011034,277569,810733,608348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004012s ]