SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029841 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029841 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380635,546728,393058,123476,36118,860051,182008,799885,841933,422873,976557,446359,365758,736656,76639,303605,991691,772117,261457,248302,165907,1004812,56374,421975,394866,255577,346531,766341,160955,380325,639376,131760,746579,26467,646010,56933,891275,252318,356955,877896,627105,631193,273014,919313,1019105,315066,744183,902007,923786,434716,214467,45131,92900,914099,304781,576607,424443,734147,329539,1041087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]