SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201565 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201565 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207451,979941,342725,216139,338886,375650,358321,864725,104292,729695,630664,865667,705253,441075,763570,883906,337672,747669,883309,891258,704994,259445,217489,410114,369247,492395,48586,1032105,563150,902522,1014280,758658,147245,601978,11063,466904,396477,970586,387328,235487,851987,283090,1002624,277634,152513,793055,791499,764251,867806,525246,737473,929375,264919,245652,266926,229596,738498,260382,107012,540215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201565 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201565 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001816s ]