SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420430 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420430 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221843,536231,429233,196033,26134,719495,424274,793719,64304,188835,228597,352398,601894,753843,679653,544680,609137,320723,962735,687489,867756,978495,624857,395738,99326,101541,216024,9259,710395,432708,476815,611412,875667,1041798,417017,36119,744500,716657,850429,92677,942834,76702,858445,872657,811067,884238,516560,753589,380039,931949,103157,722615,382879,62992,182473,509506,260532,129287,978799,1008116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]