SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041266 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041266 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988261,147637,458891,322282,893920,1044099,883359,108004,566170,1045254,484962,887740,870165,98094,481165,794851,349973,99337,699630,882331,1019244,864761,217768,187948,213934,423903,456922,689181,914426,1005224,186854,351042,828740,399919,90827,1008844,46935,248112,80198,60481,140128,340746,22521,475844,706313,605435,122745,691132,417292,410184,658147,913943,900750,433026,889614,830071,270340,116132,847073,843399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]