SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430021 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430021 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635197,531686,736568,558703,1015786,322453,195509,908812,907576,409037,311787,749387,638634,264198,301685,650360,478156,48763,299449,590537,243312,233658,814105,7931,196810,212750,735252,6536,341057,831243,823787,14249,628920,595391,585250,612005,866534,18611,116417,851091,305040,108476,324566,490456,544565,100371,56124,427369,474149,167807,1031697,734418,471195,243420,835945,417715,277381,797543,740399,236544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004765s ]