SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037939 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037939 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847001,362902,748161,163935,697528,153299,765596,10918,689435,113843,899134,151861,386037,134109,1018515,93909,526482,904759,323670,595352,801828,376750,288918,323689,94780,961495,1005492,576063,189921,548304,856009,5183,904765,279226,57788,598209,189580,449392,157112,100595,952146,675131,633242,789789,288270,507008,445621,410437,970380,1036550,552402,924407,706333,749871,97712,879659,792107,783636,748341,970854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]