SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301621 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301621 [ RunTime:0.001346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562131,303900,564822,215260,630884,896522,1016902,16137,52712,658940,116052,168455,3215,427207,993991,689878,861239,23530,188246,239361,676202,587324,919485,160754,680182,413125,496110,324332,261442,818894,966513,788553,693105,1013407,296558,1040615,616656,164768,421344,801216,21308,614380,959523,943841,861952,930114,989260,101408,478923,833518,376962,168988,60406,110193,818119,372858,223641,308053,579566,115175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]