SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412452 LIMIT 1 [ RunTime:0.001214s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412452 [ RunTime:0.003042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506893,816821,1001494,215239,744018,668731,621648,754391,341473,713842,443704,603043,388493,668293,465738,279421,968368,962854,350459,868324,331917,853258,708345,712335,974634,814345,928530,95542,134962,514477,663088,742329,36562,97408,208698,8295,877376,849776,276129,600803,585023,1012320,385921,602150,695639,739820,330981,792305,910847,172609,719498,632589,920628,419545,812570,556719,452132,540637,840787,350126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001004s ]