SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38122 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38122 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170483,832424,204480,867200,185588,397683,24101,101096,217454,692847,393857,772329,221319,916507,15418,418229,91650,805870,822891,864594,1044818,199219,781993,622387,204016,585335,268661,571372,319058,637764,630807,166065,1014150,666313,911200,526090,852283,694251,297178,133231,314487,239746,784391,299204,461564,793490,27533,724706,308454,920096,150139,206456,987524,165218,959909,671829,313160,544082,408810,304053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]