SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546061 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546061 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214240,261222,708379,134792,409223,334051,865949,563192,968260,534541,1034314,766917,163700,1033521,440144,196777,464672,345177,526035,827923,18103,291697,703283,402117,1015462,1016417,328165,782163,585242,105688,14554,949435,660216,391561,123237,421695,613038,389241,25830,660584,437525,376687,72816,657580,842591,61321,1023976,87534,373179,80294,422375,269335,360359,959161,293937,80172,950107,780673,956453,105595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]