SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46150 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46150 [ RunTime:0.003187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398628,880368,366156,199513,123465,922078,525353,432252,79424,227959,25809,122107,327610,504979,321174,746350,514555,857346,525803,65860,365981,722606,650922,282905,297393,95994,921468,535562,441712,748907,756845,124169,711901,392531,484193,822643,85899,185911,669964,737304,693305,482749,289185,761648,624413,532360,478887,653399,350525,878359,687061,407658,244150,161010,89859,887128,758886,600618,837389,897928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]