SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432943 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432943 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443130,832188,3264,345070,54956,719007,932342,1024351,399339,271924,506893,437146,566375,960965,410388,20895,828246,197834,633356,149179,87860,678571,601722,462651,232553,167870,946827,350475,571929,774895,674617,1019870,244650,758997,635460,25255,210402,539664,88803,200578,405090,284974,930126,297955,949387,349252,1040294,577023,480917,891624,245849,491477,237092,960624,81173,343788,877951,479642,294082,530977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001329s ]