SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48161 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48161 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215322,56499,139556,514049,812447,170764,584066,989542,476432,307374,72152,604840,279493,47661,260709,362276,64359,108223,330259,877154,950985,999756,315217,735162,731982,262727,648602,560381,283410,851787,932866,247893,633612,427645,666044,206428,355383,713155,67670,864653,1031984,1046533,708862,626931,771535,790607,640105,827510,592628,991980,754553,739567,465047,942128,233289,641397,409261,501087,345301,90030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]