SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001815s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485341 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485341 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538950,143379,324327,305180,59164,244833,413402,673884,760609,63236,61919,120524,101627,516542,995770,840416,760659,262273,155435,463909,136754,696992,863360,395112,803378,455752,427992,465811,352619,653910,873923,714935,649265,972761,517231,1036845,1014041,100265,886081,469929,483881,217972,854096,208226,713099,550738,314502,171322,254061,215280,869773,124746,253664,737525,421656,429111,750108,625031,1025,973933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]