SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329739 LIMIT 1 [ RunTime:0.000650s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329739 [ RunTime:0.002145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992999,338784,52004,28133,638326,554653,503623,572209,409375,426649,150455,38051,798812,183836,84566,767809,286525,854977,836043,536037,429307,30482,2006,328484,932970,896379,960094,232547,65144,623233,329380,179220,861153,847244,361379,254238,756175,312057,664277,17727,849150,740217,621854,945626,6297,925425,756934,929383,1003126,537367,232030,753515,447235,552473,50471,526961,1042106,856495,165238,542729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001386s ]