SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398814 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398814 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291625,421951,1047799,37871,605338,148851,327385,693203,991799,414172,405413,990586,700001,581650,707992,702442,989686,24894,464434,377400,551432,75077,374890,1018512,374805,88598,610197,237035,1023798,699623,361875,537012,946320,700727,836565,600844,903276,93112,61570,94296,893199,67303,674753,946611,123044,259494,90183,321675,171007,988629,906512,785517,587632,527402,341256,174494,831508,175464,620205,854411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]