SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306118 LIMIT 1 [ RunTime:0.002098s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306118 [ RunTime:0.005612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638189,341981,393229,165931,978178,309128,190443,333400,983666,1018587,322418,296666,721140,659341,945483,130845,633306,190425,559052,1029578,649716,394185,853993,150031,402267,802401,904791,991324,808802,438430,989532,944141,655392,895268,563821,371797,115672,71049,282761,625420,533497,292649,395061,755879,955476,39401,631385,404423,795527,409943,803344,259486,22449,635156,637708,649160,952625,777135,830820,140953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]