SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445009 LIMIT 1 [ RunTime:0.001016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445009 [ RunTime:0.003730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019393,201883,690999,326717,793939,224545,872399,852099,1039063,687469,598217,398438,711856,861728,169295,707782,326606,658104,801662,487744,227735,26411,47147,990761,91491,805771,62344,789444,1007574,34884,401827,412605,566421,230749,186073,311823,182770,443477,208875,211396,570959,431747,477101,945091,919526,12071,857994,475413,711686,359497,1040602,303600,881908,588058,807078,552388,400505,12406,853176,311433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002449s ]