SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403878 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403878 [ RunTime:0.004444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41923,640972,683858,732870,7163,428372,129243,286293,810870,93709,79305,189164,33683,737803,868008,542758,1009655,298183,631397,403232,23807,267580,166947,212210,1025844,433926,383133,162983,1264,961276,97147,561109,114617,78309,1042271,385289,739540,202202,238102,606024,171276,595121,922607,93850,38852,87597,741842,322084,689061,717719,1044292,147461,329031,365180,136210,292012,102969,573376,299366,601061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]