SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420653 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420653 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294240,837903,697995,603989,145677,608560,814024,956201,243480,121465,773414,439549,268309,646358,760853,1044081,442424,949022,408293,497720,904644,625918,722118,487684,68845,928500,417093,520961,818098,280800,110047,862581,211686,624033,409622,515361,1014276,769731,701464,949702,420323,978700,22038,288570,56633,289599,347497,800707,468476,836385,330356,770910,231934,129677,44092,173516,825642,931476,503804,826763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]