SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416404 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416404 [ RunTime:0.003061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043233,785454,110898,1007841,301422,605319,614283,716130,57474,119334,291534,83481,424935,824043,500174,775902,106492,997809,490403,393293,881793,71005,981616,703190,596960,630652,80164,895144,525458,398827,64998,889446,1030523,406212,552808,562327,943601,622122,553543,133152,989170,358641,819375,681175,989226,477966,552986,699290,660866,278225,662800,847799,577348,585261,115061,488842,562781,533264,80851,92906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]