SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001560s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440061 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440061 [ RunTime:0.003966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621538,1033441,897315,759709,63562,1041949,730593,552517,36805,5603,918237,980003,866634,198102,85973,913053,981872,234706,594290,54992,596041,216440,90352,513170,176688,587720,992357,964452,490901,361918,584273,907570,980444,491772,772312,497206,358782,688530,90171,11570,986764,984615,276349,497267,1015975,392349,332986,212292,218471,85903,580209,127192,862130,601167,346365,479649,75024,379245,137672,832124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]