SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464312 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464312 [ RunTime:0.002521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986361,691590,225603,633554,705006,386544,554791,66617,617256,767337,908768,224315,844238,930782,786394,837708,874626,507362,340192,550220,348495,157065,926243,761651,841789,435652,683082,164100,579889,14887,359526,652818,338353,147154,990510,534571,741170,332131,97618,244369,1014849,344711,1041467,148641,572113,1010946,634301,34228,474690,914338,902457,397845,803840,292541,195845,271241,782782,434111,860905,53035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]