SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337040 LIMIT 1 [ RunTime:0.001236s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337040 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411079,1029996,896286,184481,749380,153519,108385,481007,385773,105747,685789,201007,196267,766747,269542,1015728,265989,710224,933554,895489,508133,308665,421765,911482,365217,268328,1046316,699194,533911,959903,458524,584063,27683,412689,438554,58023,102611,7668,815449,673991,978693,801267,192612,565200,563898,291759,137350,474354,34317,567562,710190,978984,687904,352310,193831,1000835,179486,780535,414051,332717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]