SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901692 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901692 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102444,435744,23556,950595,265832,515008,991601,12981,588816,399792,745482,515419,432060,620130,335731,1014978,150881,458056,1048791,278291,494889,134112,897161,163557,621037,272033,1020838,765314,534365,473697,302873,900941,649718,574784,890069,370143,185523,834066,197,367417,588741,35886,362470,439260,138383,354478,316881,424600,825789,580316,77033,646540,1014626,1041890,729650,983360,510273,744492,557292,847199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]