SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038400 LIMIT 1 [ RunTime:0.001176s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038400 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492625,454154,1033105,393783,609297,754546,42344,365442,48205,517817,522846,471157,76364,19460,207272,508464,356789,730156,683682,538332,377482,425215,748306,1007281,193802,129125,699733,306240,616708,820718,143975,768490,482600,825699,213049,357379,351979,1013556,847226,952740,496533,364008,876081,883451,248013,77055,538935,652350,160527,698827,67901,969510,524017,156271,509326,371121,822589,729502,474360,43718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]