SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411879 LIMIT 1 [ RunTime:0.001142s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411879 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728438,591214,868249,615207,791055,55802,670266,1014931,850901,303263,717343,678345,305453,211043,303260,982496,48412,746159,123111,860812,81237,490989,651843,819889,739271,913105,696072,135006,662363,993507,773994,359722,271203,798998,581976,33185,929693,661260,914025,852981,37723,1041255,350457,385253,183035,504728,759549,396387,766891,267727,333190,644175,841325,228268,708598,567904,226859,384272,540362,738189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]