SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409010 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409010 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39991,52972,5951,863037,467948,934255,701586,725399,849498,393105,517615,727245,41498,339285,204305,711135,203298,678654,244687,79643,713428,946114,731433,537879,1023870,740010,455043,702599,612650,285355,11423,179356,670295,110845,1027805,468998,201307,69099,895833,258208,363852,721856,154147,405529,948622,863433,155822,572268,1024087,149001,1002114,582615,204673,732146,595971,141537,757055,651889,999317,246333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]