SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015567 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015567 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812946,623114,539019,36978,161776,612123,76955,759033,805799,904138,861066,1004176,845527,259312,1005780,714446,862335,91292,101985,707807,56481,283003,3019,950293,530572,215292,433110,98749,697773,544341,136321,92859,687330,107683,1046027,825798,29379,55917,166131,14854,407959,910565,812262,603796,292916,314676,667854,245401,396036,636599,448495,67006,55471,915293,742480,606991,139611,592273,585004,104345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]