SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001870s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 57064 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 57064 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584301,17727,478676,246124,180744,314972,781264,554316,542884,504012,427843,529079,798031,859486,269144,714305,92241,1014581,56098,767753,470307,29867,648098,138657,512382,367160,294814,41047,804164,1004223,183623,990513,948134,396156,775950,562157,599721,937255,703589,480351,79465,591383,210106,537274,642687,375434,256399,555805,527749,1041953,823215,711151,920475,729197,783084,620223,438364,350757,107464,758189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 57064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 57064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]