SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414411 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414411 [ RunTime:0.010042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640106,52587,572427,705791,551107,122207,398573,110256,523596,260264,950358,312696,293569,66334,964101,69273,488773,848714,269107,440370,632776,325175,416272,273009,212950,105488,633753,9886,581604,660792,60525,233069,942270,329145,405704,965867,472591,354094,351578,712145,1011755,580125,961,693367,562860,177687,283427,816557,799210,708199,18754,17185,308921,984236,814892,1010738,690820,496265,5078,356758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]