SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425027 LIMIT 1 [ RunTime:0.001018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425027 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466407,962925,241513,895742,742247,888466,515420,991983,188256,743060,13722,347500,223318,233278,953207,479849,981195,962778,638901,165300,717235,3504,882532,773907,206101,862612,10282,59237,741850,195116,386509,384567,726605,946763,226099,967660,331080,399142,965104,175304,263957,834776,37114,514784,929897,551658,153904,39392,910197,377265,203463,211091,855140,987199,103009,773922,70823,50469,619920,306456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001734s ]