SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541446 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541446 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547185,547661,4414,418303,158446,920548,207062,666970,447560,523198,294934,804792,544647,296854,903047,665729,992908,173385,723980,414003,949652,266015,681149,708956,902186,515591,464221,171009,388410,550057,421871,493329,621312,604763,904478,501814,331172,450531,176935,981599,137425,684862,1014479,443658,164867,888248,493384,749751,968160,695331,195199,534000,236644,809698,866038,403625,135269,225989,847987,695663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541446 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541446 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]